[dbo].[TaxAuthorityCategory]

Property	Value
Row Count	0
Created	10:31:41 AM Tuesday, March 02, 2010
Last Modified	1:20:17 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)	Default
TaxAuthorityCategoryKey	uniqueidentifier	16	(newid())
TaxAuthorityKey	uniqueidentifier	16
TaxCategoryKey	uniqueidentifier	16
TaxRate	decimal(12,4)	9
TaxRate2	decimal(12,4)	9	((0))
MaxAmount	decimal(18,4)	9	((0))
CombineRatesFlag	bit	1	((0))
IsPerItem	bit	1	((0))
IsTaxInclusive	bit	1	((0))
IsExemptFromIncludedTax	bit	1	((0))
QualifiesForExemptionFlag	bit	1	((1))
StartDate	datetime	8
EndDate	datetime	8
UpdatedByUserKey	uniqueidentifier	16
UpdatedOn	datetime	8
CreatedByUserKey	uniqueidentifier	16
CreatedOn	datetime	8
MarkedForDeleteOn	datetime	8

	Name	Columns	Unique
	PK_TaxAuthorityCategory	TaxAuthorityCategoryKey
	IX_TaxAuthorityCategory_CreatedByUserKey	CreatedByUserKey
	IX_TaxAuthorityCategory_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_TaxAuthorityCategory_UserMain_CreatedBy	CreatedByUserKey->[dbo].[UserMain].[UserKey]
FK_TaxAuthorityCategory_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[TaxAuthorityCategory]
(
[TaxAuthorityCategoryKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_TaxAuthorityCategoryKey] DEFAULT (newid()),
[TaxAuthorityKey] [uniqueidentifier] NOT NULL,
[TaxCategoryKey] [uniqueidentifier] NOT NULL,
[TaxRate] [decimal] (12, 4) NOT NULL,
[TaxRate2] [decimal] (12, 4) NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_TaxRate2] DEFAULT ((0)),
[MaxAmount] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_MaxAmount] DEFAULT ((0)),
[CombineRatesFlag] [bit] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_CombineRatesFlag] DEFAULT ((0)),
[IsPerItem] [bit] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_IsPerItem] DEFAULT ((0)),
[IsTaxInclusive] [bit] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_IsTaxInclusive] DEFAULT ((0)),
[IsExemptFromIncludedTax] [bit] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_IsExemptFromIncludedTax] DEFAULT ((0)),
[QualifiesForExemptionFlag] [bit] NOT NULL CONSTRAINT [DF_TaxAuthorityCategory_QualifiesForExemptionFlag] DEFAULT ((1)),
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[TaxAuthorityCategory] ADD CONSTRAINT [PK_TaxAuthorityCategory] PRIMARY KEY CLUSTERED ([TaxAuthorityCategoryKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_TaxAuthorityCategory_CreatedByUserKey] ON [dbo].[TaxAuthorityCategory] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_TaxAuthorityCategory_UpdatedByUserKey] ON [dbo].[TaxAuthorityCategory] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TaxAuthorityCategory] ADD CONSTRAINT [FK_TaxAuthorityCategory_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[TaxAuthorityCategory] ADD CONSTRAINT [FK_TaxAuthorityCategory_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO